James Keuning
James Keuning
Reactions
-
Re: Adding Names from Sheet 1 to Sheet 2 with Counter update and handling duplicates
I did this with two sheets called Sheet1 and Sheet2. Sheet1 has a column called NAMES, and it has your names in it. In Sheet2: Create a column called ROWID. This column should be an incrementing numb…1 · -
Re: Alert/Notification when line item hasn't been added
You can do this with two formulas: Max column: =IF(MAX(COLLECT([Update Date]:[Update Date], Person:Person, Person@row)) = [Update Date]@row, MAX(COLLECT([Update Date]:[Update Date], Person:Person, Pe…1 · -
Re: Checkbox Column - Column Formula
Create a column called NA and add this to the beginning of your formula and hit enter, Smartsheet will add the closing parentheses: IF(NA@row = true, "N/A", So: =IF(NA@row = true, "N/A…1 · -
Re: How to count total checked in report instead of just total number in report?
If you create a helper column for the T4C Start Date, call it T4C Start Year, and use this column formula: =YEAR([T4C Start Date]@row) The in your sheet summary formula: =COUNTIFS([T4C Completed]:[T4…1 · -
Re: Count all values in cell from selected column where name on that row is matched
I used Snagit. Its GIF feature is pretty basic, you can cut out content and that's about it. Camtasia, by the same company, is a better screen recorder with a ton of video feaures.1 ·
